package com.abtu.sms.course.mapper;

import com.abtu.sms.pojo.Course;
import com.abtu.sms.pojo.SelectCourse;

import java.sql.SQLException;
import java.util.List;

public interface CourseMapper {
    List<Course> findMySelfOptionalCourse(String tid) throws SQLException;
    int addOptionalCourse(Course course) throws SQLException;

    List<SelectCourse> findStudentSelectedCourseByCourseId(String cid) throws SQLException;

    SelectCourse findScoreByCourseIdAndStudentId(String cid, String sid) throws SQLException;

    int upDateScoreByCidAndSid(String cid, String sid, String score) throws SQLException;

    int deleteCourseById(String cid) throws SQLException;
    Course findSelectCourseByCourseId(String cid) throws SQLException;

//    com.abtu.sms.course.mapper.CourseMapper.deleteCourseById
}
